Collin County RE Data Analysis

Dataset statistics

Number of variables	39
Number of observations	135343
Missing cells	438786
Missing cells (%)	8.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	40.3 MiB
Average record size in memory	312.0 B

Variable types

CAT	20
NUM	18
BOOL	1

Reproduction

Analysis started	2020-05-28 20:16:57.565912
Analysis finished	2020-05-28 20:23:31.843316
Duration	6 minutes and 34.28 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`CloseDate` has a high cardinality: 5066 distinct values	High cardinality
`ElementarySchoolName` has a high cardinality: 183 distinct values	High cardinality
`HighSchoolName` has a high cardinality: 78 distinct values	High cardinality
`MiddleSchoolName` has a high cardinality: 88 distinct values	High cardinality
`StreetName` has a high cardinality: 15169 distinct values	High cardinality
`StreetNumber` has a high cardinality: 10356 distinct values	High cardinality
`ArchitecturalStyle` has a high cardinality: 264 distinct values	High cardinality
`TaxLegalDescription` has a high cardinality: 61882 distinct values	High cardinality
`CurrentPrice` is highly correlated with `ClosePrice` and 1 other fields	High correlation
`ClosePrice` is highly correlated with `CurrentPrice` and 1 other fields	High correlation
`ListPrice` is highly correlated with `ClosePrice` and 1 other fields	High correlation
`City` is highly correlated with `PostalCode`	High correlation
`PostalCode` is highly correlated with `City`	High correlation
`SchoolDistrict` is highly correlated with `HighSchoolName` and 2 other fields	High correlation
`HighSchoolName` is highly correlated with `SchoolDistrict`	High correlation
`MiddleSchoolName` is highly correlated with `SchoolDistrict`	High correlation
`SeniorHighSchoolName` is highly correlated with `SchoolDistrict`	High correlation
`StreetDirSuffix` is highly correlated with `StreetDirPrefix`	High correlation
`StreetDirPrefix` is highly correlated with `StreetDirSuffix`	High correlation
`HighSchoolName` has 1546 (1.1%) missing values	Missing
`Occupancy` has 24961 (18.4%) missing values	Missing
`SchoolDistrict` has 7915 (5.8%) missing values	Missing
`SeniorHighSchoolName` has 85101 (62.9%) missing values	Missing
`StreetDirPrefix` has 131949 (97.5%) missing values	Missing
`StreetDirSuffix` has 134859 (99.6%) missing values	Missing
`StreetSuffix` has 13676 (10.1%) missing values	Missing
`ArchitecturalStyle` has 10952 (8.1%) missing values	Missing
`TaxLegalDescription` has 25819 (19.1%) missing values	Missing
`OriginalListPrice` is highly skewed (γ1 = 241.4671172)	Skewed
`RATIO_ClosePrice_By_ListPrice` is highly skewed (γ1 = 367.8874324)	Skewed
`RATIO_ClosePrice_By_OriginalListPrice` is highly skewed (γ1 = 141.5756303)	Skewed
`RATIO_CurrentPrice_By_SQFT` is highly skewed (γ1 = 89.55370868)	Skewed
`YearBuilt` is highly skewed (γ1 = 97.18739673)	Skewed
`df_index` has unique values	Unique
`DOM` has 1820 (1.3%) zeros	Zeros
`ParkingSpacesGarage` has 4190 (3.1%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	135343
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	107845.69582468248
Minimum	0
Maximum	213178
Zeros	1
Zeros (%)	< 0.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	11367.1
Q1	54918.5
median	108414
Q3	161624.5
95-th percentile	203138.9
Maximum	213178
Range	213178
Interquartile range (IQR)	106706

Descriptive statistics

Standard deviation	61310.8563
Coefficient of variation (CV)	0.5685053616
Kurtosis	-1.196749337
Mean	107845.6958
Median Absolute Deviation (MAD)	53346
Skewness	-0.02478099529
Sum	1.459616001e+10
Variance	3759021100

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
8188	1	< 0.1%
150499	1	< 0.1%
15277	1	< 0.1%
9134	1	< 0.1%
11183	1	< 0.1%
54192	1	< 0.1%
56241	1	< 0.1%
52147	1	< 0.1%
39865	1	< 0.1%
33722	1	< 0.1%
Other values (135333)	135333	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
213178	1	< 0.1%
213177	1	< 0.1%
213176	1	< 0.1%
213173	1	< 0.1%
213172	1	< 0.1%

PostalCode
Categorical

HIGH CORRELATION

Distinct count	23
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

75070	27519
75035	16757
75025	13261
75023	12376
75071	11840
Other values (18)	53590

Common Values
Length

Value	Count	Frequency (%)
75070	27519	20.3%
75035	16757	12.4%
75025	13261	9.8%
75023	12376	9.1%
75071	11840	8.7%
75093	11340	8.4%
75074	8456	6.2%
75075	8268	6.1%
75069	6628	4.9%
75024	6551	4.8%
Other values (13)	12347	9.1%

Length

Max length	5
Median length	5
Mean length	5
Min length	5

BathsTotal
Real number (ℝ_≥0)

Distinct count	47
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.5545628514219425
Minimum	0.0
Maximum	9.3
Zeros	24
Zeros (%)	< 0.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	2.1
Q3	3.1
95-th percentile	4.1
Maximum	9.3
Range	9.3
Interquartile range (IQR)	1.1

Descriptive statistics

Standard deviation	0.8042001564
Coefficient of variation (CV)	0.3148093052
Kurtosis	1.975692569
Mean	2.554562851
Median Absolute Deviation (MAD)	0.1
Skewness	1.206939653
Sum	345742.2
Variance	0.6467378915

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	49365	36.5%
2.1	29236	21.6%
3.1	18349	13.6%
3	17915	13.2%
4	8056	6.0%
4.1	5264	3.9%
1	1712	1.3%
1.1	1464	1.1%
5.1	987	0.7%
3.2	683	0.5%
Other values (37)	2312	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	24	< 0.1%
0.1	2	< 0.1%
0.2	4	< 0.1%
1	1712	1.3%
1.1	1464	1.1%

Value	Count	Frequency (%)
9.3	2	< 0.1%
9.2	1	< 0.1%
8.4	1	< 0.1%
8.3	1	< 0.1%
8.2	1	< 0.1%

BedsTotal
Real number (ℝ_≥0)

Distinct count	11
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.681261683278781
Minimum	0.0
Maximum	42.0
Zeros	26
Zeros (%)	< 0.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	3
median	4
Q3	4
95-th percentile	5
Maximum	42
Range	42
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7924186912
Coefficient of variation (CV)	0.2152573654
Kurtosis	80.91174898
Mean	3.681261683
Median Absolute Deviation (MAD)	1
Skewness	1.741801345
Sum	498233
Variance	0.6279273822

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	62160	45.9%
3	49881	36.9%
5	16597	12.3%
2	5364	4.0%
6	889	0.7%
1	361	0.3%
7	49	< 0.1%
0	26	< 0.1%
8	11	< 0.1%
9	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	26	< 0.1%
1	361	0.3%
2	5364	4.0%
3	49881	36.9%
4	62160	45.9%

Value	Count	Frequency (%)
42	2	< 0.1%
9	3	< 0.1%
8	11	< 0.1%
7	49	< 0.1%
6	889	0.7%

City
Categorical

HIGH CORRELATION

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

Plano	60709
McKinney	44975
Frisco	23766
Prosper	3365
Fairview	2528

Common Values
Length

Value	Count	Frequency (%)
Plano	60709	44.9%
McKinney	44975	33.2%
Frisco	23766	17.6%
Prosper	3365	2.5%
Fairview	2528	1.9%

Length

Max length	8
Median length	6
Mean length	6.278270764
Min length	5

CloseDate
Categorical

HIGH CARDINALITY

Distinct count	5066
Unique (%)	3.7%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

4/29/2005	176
4/28/2005	160
8/28/2009	158
2/27/2015	150
4/30/2009	148
Other values (5061)	134551

Common Values
Length

Value	Count	Frequency (%)
4/29/2005	176	0.1%
4/28/2005	160	0.1%
8/28/2009	158	0.1%
2/27/2015	150	0.1%
4/30/2009	148	0.1%
6/30/2005	144	0.1%
3/31/2005	138	0.1%
5/29/2009	128	0.1%
4/15/2005	128	0.1%
6/26/2009	128	0.1%
Other values (5056)	133885	98.9%

Length

Max length	10
Median length	9
Mean length	8.991776449
Min length	8

ClosePrice
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	9996
Unique (%)	7.4%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	282111.8280486471
Minimum	70.0
Maximum	6547500.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	70
5-th percentile	118726
Q1	171000
median	240000
Q3	331000
95-th percentile	579692.75
Maximum	6547500
Range	6547430
Interquartile range (IQR)	160000

Descriptive statistics

Standard deviation	192542.8604
Coefficient of variation (CV)	0.6825054507
Kurtosis	57.30568401
Mean	282111.828
Median Absolute Deviation (MAD)	75100
Skewness	5.026583132
Sum	3.818157903e+10
Variance	3.707275308e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
250000	1096	0.8%
225000	975	0.7%
275000	931	0.7%
300000	883	0.7%
165000	868	0.6%
265000	857	0.6%
210000	853	0.6%
260000	851	0.6%
175000	845	0.6%
215000	844	0.6%
Other values (9986)	126339	93.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
70	1	< 0.1%
81	1	< 0.1%
110	1	< 0.1%
165	1	< 0.1%
220	1	< 0.1%

Value	Count	Frequency (%)
6547500	1	< 0.1%
5720000	1	< 0.1%
5150000	1	< 0.1%
4900000	1	< 0.1%
4275000	1	< 0.1%

CurrentPrice
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	9996
Unique (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	282118.57304596464
Minimum	70.0
Maximum	6547500.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	70
5-th percentile	118726
Q1	171000
median	240000
Q3	331000
95-th percentile	579880
Maximum	6547500
Range	6547430
Interquartile range (IQR)	160000

Descriptive statistics

Standard deviation	192558.1382
Coefficient of variation (CV)	0.6825432871
Kurtosis	57.28913019
Mean	282118.573
Median Absolute Deviation (MAD)	75100
Skewness	5.026031861
Sum	3.818277403e+10
Variance	3.707863659e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
250000	1096	0.8%
225000	975	0.7%
275000	931	0.7%
300000	883	0.7%
165000	868	0.6%
265000	857	0.6%
210000	853	0.6%
260000	851	0.6%
175000	845	0.6%
215000	844	0.6%
Other values (9986)	126340	93.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
70	1	< 0.1%
81	1	< 0.1%
110	1	< 0.1%
165	1	< 0.1%
220	1	< 0.1%

Value	Count	Frequency (%)
6547500	1	< 0.1%
5720000	1	< 0.1%
5150000	1	< 0.1%
4900000	1	< 0.1%
4275000	1	< 0.1%

DOM
Real number (ℝ_≥0)

ZEROS

Distinct count	572
Unique (%)	0.4%
Missing	23
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	48.98737806680461
Minimum	0.0
Maximum	1649.0
Zeros	1820
Zeros (%)	1.3%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	9
median	28
Q3	67
95-th percentile	163
Maximum	1649
Range	1649
Interquartile range (IQR)	58

Descriptive statistics

Standard deviation	60.37183771
Coefficient of variation (CV)	1.232395774
Kurtosis	25.05132464
Mean	48.98737807
Median Absolute Deviation (MAD)	22
Skewness	3.257590844
Sum	6628972
Variance	3644.758788

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	5303	3.9%
4	5078	3.8%
5	4353	3.2%
2	3903	2.9%
6	3510	2.6%
7	3245	2.4%
10	2780	2.1%
8	2719	2.0%
11	2451	1.8%
9	2389	1.8%
Other values (562)	99589	73.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1820	1.3%
1	1858	1.4%
2	3903	2.9%
3	5303	3.9%
4	5078	3.8%

Value	Count	Frequency (%)
1649	2	< 0.1%
1324	1	< 0.1%
1243	1	< 0.1%
1091	1	< 0.1%
1066	1	< 0.1%

ElementarySchoolName
Categorical

HIGH CARDINALITY

Distinct count	183
Unique (%)	0.1%
Missing	218
Missing (%)	0.2%
Memory size	1.0 MiB

Christie	5264
Thomas	2852
Glenoaks	2731
Johnson	2721
Curtsinger	2551
Other values (178)	119006

Common Values
Length

Value	Count	Frequency (%)
Christie	5264	3.9%
Thomas	2852	2.1%
Glenoaks	2731	2.0%
Johnson	2721	2.0%
Curtsinger	2551	1.9%
Gunstream	2513	1.9%
Bennett	2483	1.8%
Shawnee	2395	1.8%
Wolford	2310	1.7%
Spears	2303	1.7%
Other values (173)	107002	79.1%

Length

Max length	27
Median length	7
Mean length	7.606185765
Min length	3

HighSchoolName
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct count	78
Unique (%)	0.1%
Missing	1546
Missing (%)	1.1%
Memory size	1.0 MiB

Mckinney	14001
Jasper	13073
Clark	12368
Centennial	11922
Vines	11128
Other values (73)	71305

Common Values
Length

Value	Count	Frequency (%)
Mckinney	14001	10.3%
Jasper	13073	9.7%
Clark	12368	9.1%
Centennial	11922	8.8%
Vines	11128	8.2%
Mckinney Boyd	10786	8.0%
Shepton	8544	6.3%
Frisco	8426	6.2%
Mckinneyno	8315	6.1%
Williams	7300	5.4%
Other values (68)	27934	20.6%

Length

Max length	20
Median length	7
Mean length	7.675565046
Min length	3

AssociationType
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	1.0 MiB

Mandatory	86564
None	40966
Voluntary	7811

Common Values
Length

Value	Count	Frequency (%)
Mandatory	86564	64.0%
None	40966	30.3%
Voluntary	7811	5.8%
(Missing)	2	< 0.1%

Length

Max length	9
Median length	9
Mean length	7.48649727
Min length	3

ListPrice
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	6107
Unique (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	288127.66547955933
Minimum	1.0
Maximum	6750000.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	1
5-th percentile	120000
Q1	174900
median	244000
Q3	339000
95-th percentile	597860
Maximum	6750000
Range	6749999
Interquartile range (IQR)	164100

Descriptive statistics

Standard deviation	203843.7197
Coefficient of variation (CV)	0.7074770808
Kurtosis	69.75373719
Mean	288127.6655
Median Absolute Deviation (MAD)	76500
Skewness	5.563886769
Sum	3.899606263e+10
Variance	4.155226205e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
169900	1657	1.2%
179900	1492	1.1%
159900	1491	1.1%
199900	1459	1.1%
249900	1434	1.1%
189900	1372	1.0%
149900	1319	1.0%
299900	1258	0.9%
139900	1184	0.9%
225000	1178	0.9%
Other values (6097)	121499	89.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
1995	1	< 0.1%
9900	1	< 0.1%
13200	2	< 0.1%
13500	1	< 0.1%

Value	Count	Frequency (%)
6750000	1	< 0.1%
6399000	2	< 0.1%
5400000	1	< 0.1%
5150000	1	< 0.1%
4900000	2	< 0.1%

LotSize
Categorical

Distinct count	10
Unique (%)	< 0.1%
Missing	14
Missing (%)	< 0.1%
Memory size	1.0 MiB

Less Than .5 Acre (not Zero)	119650
.5 Acre to .99 Acre	6369
Condo/Townhome Lot	3391
Zero Lot	2758
1 Acre to 2.99 Acres	2545
Other values (5)	616

Common Values
Length

Value	Count	Frequency (%)
Less Than .5 Acre (not Zero)	119650	88.4%
.5 Acre to .99 Acre	6369	4.7%
Condo/Townhome Lot	3391	2.5%
Zero Lot	2758	2.0%
1 Acre to 2.99 Acres	2545	1.9%
3 Acres to 4.99 Acres	315	0.2%
5 Acres to 9.99 Acres	162	0.1%
10 Acres to 49.99 Acres	128	0.1%
Over 100 Acres	9	< 0.1%
50 Acres to 100 Acres	2	< 0.1%
(Missing)	14	< 0.1%

Length

Max length	28
Median length	28
Mean length	26.73491795
Min length	3

MiddleSchoolName
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	88
Unique (%)	0.1%
Missing	699
Missing (%)	0.5%
Memory size	1.0 MiB

Dowell	8740
Evans	7431
Carpenter	7279
Faubion	7171
Renner	6667
Other values (83)	97356

Common Values
Length

Value	Count	Frequency (%)
Dowell	8740	6.5%
Evans	7431	5.5%
Carpenter	7279	5.4%
Faubion	7171	5.3%
Renner	6667	4.9%
Wester	6654	4.9%
Clark	6624	4.9%
Haggard	6317	4.7%
Roach	5863	4.3%
Robinson	5305	3.9%
Other values (78)	66593	49.2%

Length

Max length	21
Median length	6
Mean length	7.014821601
Min length	3

MLSNumber
Real number (ℝ_≥0)

Distinct count	124901
Unique (%)	92.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11896387.741227843
Minimum	9308485.0
Maximum	14320678.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	9308485
5-th percentile	9714982.4
Q1	10758605
median	11710551
Q3	13275723
95-th percentile	14048025.1
Maximum	14320678
Range	5012193
Interquartile range (IQR)	2517118

Descriptive statistics

Standard deviation	1378452.483
Coefficient of variation (CV)	0.115871516
Kurtosis	-1.24648359
Mean	11896387.74
Median Absolute Deviation (MAD)	1309602
Skewness	0.1485541609
Sum	1.610092806e+12
Variance	1.900131248e+12

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10265120	3	< 0.1%
10283463	3	< 0.1%
10293484	3	< 0.1%
10265904	3	< 0.1%
10276005	3	< 0.1%
10295089	3	< 0.1%
10299566	3	< 0.1%
10214609	3	< 0.1%
10279349	3	< 0.1%
10214578	3	< 0.1%
Other values (124891)	135313	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9308485	1	< 0.1%
9325434	1	< 0.1%
9326879	1	< 0.1%
9377660	1	< 0.1%
9388582	1	< 0.1%

Value	Count	Frequency (%)
14320678	1	< 0.1%
14320220	1	< 0.1%
14313727	1	< 0.1%
14311113	1	< 0.1%
14311028	1	< 0.1%

NumberOfDiningAreas
Real number (ℝ_≥0)

Distinct count	8
Unique (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	1.7554030190407932
Minimum	0.0
Maximum	9.0
Zeros	723
Zeros (%)	0.5%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	2
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4499385172
Coefficient of variation (CV)	0.2563163629
Kurtosis	1.266541543
Mean	1.755403019
Median Absolute Deviation (MAD)	0
Skewness	-1.181933479
Sum	237578
Variance	0.2024446693

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	102199	75.5%
1	32059	23.7%
0	723	0.5%
3	334	0.2%
4	19	< 0.1%
5	4	< 0.1%
7	2	< 0.1%
9	1	< 0.1%
(Missing)	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	723	0.5%
1	32059	23.7%
2	102199	75.5%
3	334	0.2%
4	19	< 0.1%

Value	Count	Frequency (%)
9	1	< 0.1%
7	2	< 0.1%
5	4	< 0.1%
4	19	< 0.1%
3	334	0.2%

NumberOfLivingAreas
Real number (ℝ_≥0)

Distinct count	10
Unique (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	2.067325737760636
Minimum	0.0
Maximum	9.0
Zeros	68
Zeros (%)	0.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	4
Maximum	9
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.9108953261
Coefficient of variation (CV)	0.4406152884
Kurtosis	1.019823253
Mean	2.067325738
Median Absolute Deviation (MAD)	1
Skewness	0.7456857934
Sum	279796
Variance	0.8297302952

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	56012	41.4%
1	39798	29.4%
3	31614	23.4%
4	6517	4.8%
5	1061	0.8%
6	189	0.1%
0	68	0.1%
7	52	< 0.1%
8	18	< 0.1%
9	13	< 0.1%
(Missing)	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	68	0.1%
1	39798	29.4%
2	56012	41.4%
3	31614	23.4%
4	6517	4.8%

Value	Count	Frequency (%)
9	13	< 0.1%
8	18	< 0.1%
7	52	< 0.1%
6	189	0.1%
5	1061	0.8%

NumberOfStories
Real number (ℝ_≥0)

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.5312576195296395
Minimum	0.0
Maximum	5.0
Zeros	260
Zeros (%)	0.2%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5119453135
Coefficient of variation (CV)	0.3343299697
Kurtosis	-1.55340794
Mean	1.53125762
Median Absolute Deviation (MAD)	0
Skewness	-0.05709355423
Sum	207245
Variance	0.262088004

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	70974	52.4%
1	63524	46.9%
3	570	0.4%
0	260	0.2%
4	12	< 0.1%
5	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	260	0.2%
1	63524	46.9%
2	70974	52.4%
3	570	0.4%
4	12	< 0.1%

Value	Count	Frequency (%)
5	3	< 0.1%
4	12	< 0.1%
3	570	0.4%
2	70974	52.4%
1	63524	46.9%

Occupancy
Categorical

MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	24961
Missing (%)	18.4%
Memory size	1.0 MiB

Owner	74867
Vacant	32514
Tenant	3001

Common Values
Length

Value	Count	Frequency (%)
Owner	74867	55.3%
Vacant	32514	24.0%
Tenant	3001	2.2%
(Missing)	24961	18.4%

Length

Max length	6
Median length	5
Mean length	4.893551938
Min length	3

OriginalListPrice
Real number (ℝ_≥0)

SKEWED

Distinct count	6110
Unique (%)	4.5%
Missing	6
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	302718.13430178
Minimum	0.0
Maximum	430000000.0
Zeros	18
Zeros (%)	< 0.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	123972
Q1	175000
median	248000
Q3	345000
95-th percentile	612180
Maximum	430000000
Range	430000000
Interquartile range (IQR)	170000

Descriptive statistics

Standard deviation	1491181.774
Coefficient of variation (CV)	4.925974381
Kurtosis	63369.7939
Mean	302718.1343
Median Absolute Deviation (MAD)	78100
Skewness	241.4671172
Sum	4.096896414e+10
Variance	2.223623084e+12

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
169900	1532	1.1%
179900	1453	1.1%
249900	1361	1.0%
159900	1344	1.0%
189900	1326	1.0%
199900	1324	1.0%
299900	1195	0.9%
149900	1192	0.9%
225000	1175	0.9%
275000	1111	0.8%
Other values (6100)	122324	90.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	18	< 0.1%
1	10	< 0.1%
320	1	< 0.1%
1000	3	< 0.1%
1990	1	< 0.1%

Value	Count	Frequency (%)
430000000	1	< 0.1%
299900900	1	< 0.1%
126500000	1	< 0.1%
34990000	1	< 0.1%
27990000	2	< 0.1%

ParkingSpacesGarage
Real number (ℝ_≥0)

ZEROS

Distinct count	10
Unique (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	2.121950318452513
Minimum	0.0
Maximum	9.0
Zeros	4190
Zeros (%)	3.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6099141385
Coefficient of variation (CV)	0.287430923
Kurtosis	8.547737792
Mean	2.121950318
Median Absolute Deviation (MAD)	0
Skewness	-0.003701813448
Sum	287189
Variance	0.3719952564

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	103311	76.3%
3	23985	17.7%
0	4190	3.1%
1	2452	1.8%
4	1103	0.8%
5	160	0.1%
6	89	0.1%
7	20	< 0.1%
9	18	< 0.1%
8	14	< 0.1%
(Missing)	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4190	3.1%
1	2452	1.8%
2	103311	76.3%
3	23985	17.7%
4	1103	0.8%

Value	Count	Frequency (%)
9	18	< 0.1%
8	14	< 0.1%
7	20	< 0.1%
6	89	0.1%
5	160	0.1%

PoolYN
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	1.0 MiB

False	102369
True	32973
(Missing)	1

Frequency Table

Value	Count	Frequency (%)
False	102369	75.6%
True	32973	24.4%
(Missing)	1	< 0.1%

PropertySubType
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

RES-Single Family	128432
RES-Townhouse	4253
RES-Condo	1686
RES-Half Duplex	911
RES-Farm/Ranch	61

Common Values
Length

Value	Count	Frequency (%)
RES-Single Family	128432	94.9%
RES-Townhouse	4253	3.1%
RES-Condo	1686	1.2%
RES-Half Duplex	911	0.7%
RES-Farm/Ranch	61	< 0.1%

Length

Max length	17
Median length	17
Mean length	16.75983243
Min length	9

RATIO_ClosePrice_By_ListPrice
Real number (ℝ_≥0)

SKEWED

Distinct count	15559
Unique (%)	11.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	1.7600840672518505
Minimum	0.0005200000000000001
Maximum	105000.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0.00052
5-th percentile	0.92563
Q1	0.96674
median	0.98508
Q3	1
95-th percentile	1.0356
Maximum	105000
Range	104999.9995
Interquartile range (IQR)	0.03326

Descriptive statistics

Standard deviation	285.4101285
Coefficient of variation (CV)	162.1571002
Kurtosis	135341.4414
Mean	1.760084067
Median Absolute Deviation (MAD)	0.01498
Skewness	367.8874324
Sum	238213.2978
Variance	81458.94144

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	19045	14.1%
0.98039	311	0.2%
0.96	308	0.2%
0.97143	291	0.2%
0.97561	275	0.2%
0.95238	275	0.2%
0.97778	273	0.2%
0.96667	264	0.2%
0.96774	262	0.2%
0.98	247	0.2%
Other values (15549)	113791	84.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.00052	1	< 0.1%
0.00054	1	< 0.1%
0.00095	1	< 0.1%
0.00096	1	< 0.1%
0.00097	1	< 0.1%

Value	Count	Frequency (%)
105000	1	< 0.1%
150.37594	1	< 0.1%
10	1	< 0.1%
9.47867	1	< 0.1%
7.54717	1	< 0.1%

RATIO_ClosePrice_By_OriginalListPrice
Real number (ℝ_≥0)

SKEWED

Distinct count	20706
Unique (%)	15.3%
Missing	25
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	15.783095333067294
Minimum	0.0005099999999999999
Maximum	378000.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0.00051
5-th percentile	0.86625
Q1	0.94275
median	0.97397
Q3	1
95-th percentile	1.0351015
Maximum	378000
Range	377999.9995
Interquartile range (IQR)	0.05725

Descriptive statistics

Standard deviation	1840.105945
Coefficient of variation (CV)	116.58714
Kurtosis	22401.75817
Mean	15.78309533
Median Absolute Deviation (MAD)	0.02603
Skewness	141.5756303
Sum	2135736.894
Variance	3385989.888

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	13453	9.9%
0.95238	298	0.2%
0.96	288	0.2%
0.97143	247	0.2%
0.96667	235	0.2%
0.93333	233	0.2%
0.95	229	0.2%
0.96774	225	0.2%
0.90909	215	0.2%
0.97778	211	0.2%
Other values (20696)	119684	88.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.00051	1	< 0.1%
0.00052	1	< 0.1%
0.00092	1	< 0.1%
0.00093	1	< 0.1%
0.00094	1	< 0.1%

Value	Count	Frequency (%)
378000	1	< 0.1%
276000	1	< 0.1%
225000	1	< 0.1%
222500	1	< 0.1%
187500	1	< 0.1%

RATIO_CurrentPrice_By_SQFT
Real number (ℝ_≥0)

SKEWED

Distinct count	15772
Unique (%)	11.7%
Missing	36
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	104.60618068540431
Minimum	0.03
Maximum	10000.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0.03
5-th percentile	64.26
Q1	80.56
median	96.7
Q3	124.005
95-th percentile	164.027
Maximum	10000
Range	9999.97
Interquartile range (IQR)	43.445

Descriptive statistics

Standard deviation	43.23548462
Coefficient of variation (CV)	0.4133167308
Kurtosis	20286.53607
Mean	104.6061807
Median Absolute Deviation (MAD)	19.69
Skewness	89.55370868
Sum	14153948.49
Variance	1869.30713

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
83.33	86	0.1%
100	85	0.1%
125	63	< 0.1%
90.91	60	< 0.1%
111.11	48	< 0.1%
83.29	47	< 0.1%
85.71	45	< 0.1%
96.15	44	< 0.1%
76.92	44	< 0.1%
92.59	43	< 0.1%
Other values (15762)	134742	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.03	1	< 0.1%
0.04	1	< 0.1%
0.07	1	< 0.1%
0.08	2	< 0.1%
0.1	1	< 0.1%

Value	Count	Frequency (%)
10000	1	< 0.1%
1217.73	1	< 0.1%
1000	1	< 0.1%
865.38	1	< 0.1%
779.9	1	< 0.1%

SchoolDistrict
Categorical

HIGH CORRELATION
MISSING

Distinct count	13
Unique (%)	< 0.1%
Missing	7915
Missing (%)	5.8%
Memory size	1.0 MiB

Plano ISD	50384
Frisco ISD	35439
McKinney ISD	31795
Prosper ISD	6688
Lovejoy ISD	1834
Other values (8)	1288

Common Values
Length

Value	Count	Frequency (%)
Plano ISD	50384	37.2%
Frisco ISD	35439	26.2%
McKinney ISD	31795	23.5%
Prosper ISD	6688	4.9%
Lovejoy ISD	1834	1.4%
Allen ISD	759	0.6%
Lewisville ISD	302	0.2%
Melissa ISD	140	0.1%
Princeton ISD	47	< 0.1%
Celina ISD	33	< 0.1%
Other values (3)	7	< 0.1%
(Missing)	7915	5.8%

Length

Max length	14
Median length	10
Mean length	9.756707033
Min length	3

SellerType
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	978
Missing (%)	0.7%
Memory size	1.0 MiB

Individual(s)	124987
Lender/REO	9378

Common Values
Length

Value	Count	Frequency (%)
Individual(s)	124987	92.3%
Lender/REO	9378	6.9%
(Missing)	978	0.7%

Length

Max length	13
Median length	13
Mean length	12.7198673
Min length	3

SeniorHighSchoolName
Categorical

HIGH CORRELATION
MISSING

Distinct count	20
Unique (%)	< 0.1%
Missing	85101
Missing (%)	62.9%
Memory size	1.0 MiB

Plano Senior	19599
Planoeast	9819
Planowest	9284
Plano West	5410
Plano East	4238
Other values (15)	1892

Common Values
Length

Value	Count	Frequency (%)
Plano Senior	19599	14.5%
Planoeast	9819	7.3%
Planowest	9284	6.9%
Plano West	5410	4.0%
Plano East	4238	3.1%
Plano Sr	1710	1.3%
Centennial	72	0.1%
Frisco	65	< 0.1%
Plano	12	< 0.1%
Jasper	7	< 0.1%
Other values (10)	26	< 0.1%
(Missing)	85101	62.9%

Length

Max length	12
Median length	3
Mean length	5.718552123
Min length	3

SqFtTotal
Real number (ℝ_≥0)

Distinct count	5663
Unique (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2623.4577924236937
Minimum	0.0
Maximum	17306.0
Zeros	36
Zeros (%)	< 0.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1388
Q1	1892
median	2413
Q3	3186
95-th percentile	4406
Maximum	17306
Range	17306
Interquartile range (IQR)	1294

Descriptive statistics

Standard deviation	1019.422058
Coefficient of variation (CV)	0.3885795535
Kurtosis	5.887842745
Mean	2623.457792
Median Absolute Deviation (MAD)	611
Skewness	1.491585428
Sum	355066648
Variance	1039221.332

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1930	248	0.2%
2098	217	0.2%
1785	213	0.2%
1659	207	0.2%
1868	204	0.2%
1535	202	0.1%
2297	197	0.1%
1848	196	0.1%
1860	195	0.1%
2076	192	0.1%
Other values (5653)	133272	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	36	< 0.1%
49	1	< 0.1%
219	1	< 0.1%
520	1	< 0.1%
525	1	< 0.1%

Value	Count	Frequency (%)
17306	1	< 0.1%
15042	1	< 0.1%
15000	2	< 0.1%
14962	1	< 0.1%
14919	1	< 0.1%

StreetDirPrefix
Categorical

HIGH CORRELATION
MISSING

Distinct count	7
Unique (%)	0.2%
Missing	131949
Missing (%)	97.5%
Memory size	1.0 MiB

N	1037
W	970
S	829
E	544
NW	6
Other values (2)	8

Common Values
Length

Value	Count	Frequency (%)
N	1037	0.8%
W	970	0.7%
S	829	0.6%
E	544	0.4%
NW	6	< 0.1%
NE	5	< 0.1%
SW	3	< 0.1%
(Missing)	131949	97.5%

Length

Max length	3
Median length	3
Mean length	2.949949388
Min length	1

StreetDirSuffix
Categorical

HIGH CORRELATION
MISSING

Distinct count	8
Unique (%)	1.7%
Missing	134859
Missing (%)	99.6%
Memory size	1.0 MiB

N	159
S	143
W	103
E	73
NW	3
Other values (3)	3

Common Values
Length

Value	Count	Frequency (%)
N	159	0.1%
S	143	0.1%
W	103	0.1%
E	73	0.1%
NW	3	< 0.1%
NE	1	< 0.1%
SW	1	< 0.1%
SE	1	< 0.1%
(Missing)	134859	99.6%

Length

Max length	3
Median length	3
Mean length	2.992892133
Min length	1

StreetName
Categorical

HIGH CARDINALITY

Distinct count	15169
Unique (%)	11.2%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

Park	288
Virginia Hills	273
Preston	249
Cross Bend	220
Hickory	191
Other values (15164)	134122

Common Values
Length

Value	Count	Frequency (%)
Park	288	0.2%
Virginia Hills	273	0.2%
Preston	249	0.2%
Cross Bend	220	0.2%
Hickory	191	0.1%
Spring Creek	173	0.1%
14th	149	0.1%
Teakwood	146	0.1%
Mason	131	0.1%
Scenic Ranch	129	0.1%
Other values (15159)	133394	98.6%

Length

Max length	20
Median length	9
Mean length	8.910006428
Min length	1

StreetNumber
Categorical

HIGH CARDINALITY

Distinct count	10356
Unique (%)	7.7%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

2601	333
575	296
3801	284
3101	282
2204	267
Other values (10351)	133881

Common Values
Length

Value	Count	Frequency (%)
2601	333	0.2%
575	296	0.2%
3801	284	0.2%
3101	282	0.2%
2204	267	0.2%
2400	248	0.2%
8400	246	0.2%
2524	230	0.2%
2200	228	0.2%
2500	212	0.2%
Other values (10346)	132717	98.1%

Length

Max length	9
Median length	4
Mean length	3.99199072
Min length	1

StreetSuffix
Categorical

MISSING

Distinct count	44
Unique (%)	< 0.1%
Missing	13676
Missing (%)	10.1%
Memory size	1.0 MiB

Drive	65002
Lane	20263
Court	8598
Trail	5685
Street	4757
Other values (39)	17362

Common Values
Length

Value	Count	Frequency (%)
Drive	65002	48.0%
Lane	20263	15.0%
Court	8598	6.4%
Trail	5685	4.2%
Street	4757	3.5%
Road	4696	3.5%
Circle	3318	2.5%
Way	3300	2.4%
Place	1942	1.4%
Avenue	1261	0.9%
Other values (34)	2845	2.1%
(Missing)	13676	10.1%

Length

Max length	9
Median length	5
Mean length	4.670984092
Min length	3

ArchitecturalStyle
Categorical

HIGH CARDINALITY
MISSING

Distinct count	264
Unique (%)	0.2%
Missing	10952
Missing (%)	8.1%
Memory size	1.0 MiB

Traditional	113275
Ranch	2336
Contemporary/Modern	1803
Ranch, Traditional	1242
Mediterranean	752
Other values (259)	4983

Common Values
Length

Value	Count	Frequency (%)
Traditional	113275	83.7%
Ranch	2336	1.7%
Contemporary/Modern	1803	1.3%
Ranch, Traditional	1242	0.9%
Mediterranean	752	0.6%
Other	534	0.4%
Contemporary/Modern, Traditional	448	0.3%
French	289	0.2%
Craftsman	287	0.2%
French, Traditional	267	0.2%
Other values (254)	3158	2.3%
(Missing)	10952	8.1%

Length

Max length	98
Median length	11
Mean length	10.66080255
Min length	3

TaxLegalDescription
Categorical

HIGH CARDINALITY
MISSING

Distinct count	61882
Unique (%)	56.5%
Missing	25819
Missing (%)	19.1%
Memory size	1.0 MiB

SPRING CREEK PARKWAY ESTATES W	217
Spring Creek Parkway Estates W	137
WELLINGTON AT PRESTON MEADOWS	131
LAKES OF PRESTON VINEYARDS VIL	113
VILLAGES OF WHITE ROCK CREEK #	106
Other values (61877)	108820

Common Values
Length

Value	Count	Frequency (%)
SPRING CREEK PARKWAY ESTATES W	217	0.2%
Spring Creek Parkway Estates W	137	0.1%
WELLINGTON AT PRESTON MEADOWS	131	0.1%
LAKES OF PRESTON VINEYARDS VIL	113	0.1%
VILLAGES OF WHITE ROCK CREEK #	106	0.1%
Wellington At Preston Meadows	91	0.1%
VALOR POINTE - THE RESERVE AT WESTRIDGE PHASE	88	0.1%
Winsor Meadows At Westridge #0	87	0.1%
BILTMORE SWIM & RACQUET CLUB #	77	0.1%
PLANTATION RESORT AUGUSTA FARM	75	0.1%
Other values (61872)	108402	80.1%
(Missing)	25819	19.1%

Length

Max length	50
Median length	30
Mean length	27.52241342
Min length	1

YearBuilt
Real number (ℝ_≥0)

SKEWED

Distinct count	142
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1994.8070605794167
Minimum	0.0
Maximum	9999.0
Zeros	9
Zeros (%)	< 0.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1972
Q1	1988
median	1997
Q3	2003
95-th percentile	2010
Maximum	9999
Range	9999
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	75.08899798
Coefficient of variation (CV)	0.03764223592
Kurtosis	10524.21113
Mean	1994.807061
Median Absolute Deviation (MAD)	7
Skewness	97.18739673
Sum	269983172
Variance	5638.357618

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2005	6400	4.7%
1998	6288	4.6%
2001	6190	4.6%
2000	6144	4.5%
1999	6067	4.5%
2006	5978	4.4%
2004	5946	4.4%
1997	5649	4.2%
2003	5329	3.9%
1996	5266	3.9%
Other values (132)	76086	56.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9	< 0.1%
1857	3	< 0.1%
1860	2	< 0.1%
1876	2	< 0.1%
1877	1	< 0.1%

Value	Count	Frequency (%)
9999	11	< 0.1%
2020	1	< 0.1%
2019	11	< 0.1%
2018	55	< 0.1%
2017	190	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	df_index	PostalCode	BathsTotal	BedsTotal	City	CloseDate	ClosePrice	CurrentPrice	DOM	ElementarySchoolName	HighSchoolName	AssociationType	ListPrice	LotSize	MiddleSchoolName	MLSNumber	NumberOfDiningAreas	NumberOfLivingAreas	NumberOfStories	Occupancy	OriginalListPrice	ParkingSpacesGarage	PoolYN	PropertySubType	RATIO_ClosePrice_By_ListPrice	RATIO_ClosePrice_By_OriginalListPrice	RATIO_CurrentPrice_By_SQFT	SchoolDistrict	SellerType	SeniorHighSchoolName	SqFtTotal	StreetDirPrefix	StreetDirSuffix	StreetName	StreetNumber	StreetSuffix	ArchitecturalStyle	TaxLegalDescription	YearBuilt
0	0	75071	1.0	2.0	McKinney	10/3/2014	150000.0	150000.0	1649.0	John A Baker	Prosper	None	230000.0	1 Acre to 2.99 Acres	Rogers	11363157.0	1.0	1.0	1.0	Owner	274900.0	2.0	False	RES-Farm/Ranch	0.65217	0.54565	151.82	Prosper ISD	Individual(s)	NaN	988.0	N	NaN	Custer	5841	Road	Early American	Abstract A0412 Horn, George, T	1930.0
1	1	75071	3.0	4.0	McKinney	10/3/2014	400000.0	400000.0	1649.0	John A Baker	Prosper	None	400000.0	3 Acres to 4.99 Acres	Rogers	11363138.0	2.0	2.0	1.0	Tenant	424900.0	2.0	False	RES-Single Family	1.00000	0.94140	152.09	Prosper ISD	Individual(s)	NaN	2630.0	NaN	NaN	Custer	5799	Road	Traditional	NaN	1965.0
2	2	75034	5.0	5.0	Frisco	7/29/2013	555000.0	555000.0	1324.0	Spears	Frisco	Mandatory	530200.0	Less Than .5 Acre (not Zero)	Hunt	11281961.0	2.0	3.0	2.0	Owner	800000.0	3.0	True	RES-Single Family	1.04677	0.69375	119.92	Frisco ISD	Individual(s)	NaN	4628.0	NaN	NaN	Lago Vista	5507	Lane	Traditional	Starwood #04 Village #15, Bloc	2004.0
3	3	75078	3.1	3.0	Prosper	10/17/2012	1490000.0	1490000.0	1243.0	Prosper	Prosper	None	1900000.0	10 Acres to 49.99 Acres	Prosper	11207426.0	2.0	3.0	2.0	NaN	2300000.0	3.0	False	RES-Farm/Ranch	0.78421	0.64783	322.93	Prosper ISD	Individual(s)	NaN	4614.0	E	NaN	Frontier	2380	Parkway	Victorian	W.T. Horn Survey, A-376	1990.0
4	7	75034	5.1	5.0	Frisco	12/19/2013	1138000.0	1138000.0	1091.0	Smith	Frisco	Mandatory	1190000.0	Less Than .5 Acre (not Zero)	Staley	11503844.0	2.0	3.0	2.0	NaN	1350000.0	3.0	True	RES-Single Family	0.95630	0.84296	217.05	Frisco ISD	Individual(s)	NaN	5243.0	NaN	NaN	Briarwood	3074	Lane	Traditional	NaN	2006.0
5	9	75093	5.2	6.0	Plano	6/28/2013	906500.0	906500.0	1066.0	Huffman	Shepton	Mandatory	998500.0	Less Than .5 Acre (not Zero)	Renner	11424721.0	2.0	3.0	2.0	Owner	1150000.0	4.0	True	RES-Single Family	0.90786	0.78826	148.97	Plano ISD	Individual(s)	Planowest	6085.0	NaN	NaN	Cliffview	1816	Drive	Contemporary/Modern	Cliffs Of Gleneagles, Blk A, L	1994.0
6	10	75075	2.1	3.0	Plano	3/17/2014	116994.0	116994.0	1047.0	Saigling	Vines	Mandatory	117000.0	Less Than .5 Acre (not Zero)	Haggard	11566790.0	1.0	2.0	2.0	Owner	137500.0	2.0	False	RES-Townhouse	0.99995	0.85087	66.40	Plano ISD	Individual(s)	Plano Senior	1762.0	NaN	NaN	Devonshire	3225	Drive	Contemporary/Modern, French, Traditional	Cobblestone Townhome Community	1987.0
7	16	75070	3.2	3.0	McKinney	12/21/2015	870000.0	870000.0	950.0	Comstock	Liberty	Mandatory	899000.0	Condo/Townhome Lot	Scoggins	11933761.0	2.0	2.0	2.0	Vacant	1045000.0	2.0	False	RES-Condo	0.96774	0.83254	203.99	Frisco ISD	Individual(s)	NaN	4265.0	NaN	NaN	Settlement	5724	Way	Traditional	RESIDENCES AT THE GRAND LODGE	2012.0
8	20	75078	2.1	3.0	Prosper	9/17/2014	535000.0	535000.0	883.0	Judy Rucker	Prosper	None	594900.0	10 Acres to 49.99 Acres	Reynolds	11756658.0	2.0	1.0	2.0	Owner	722775.0	2.0	False	RES-Single Family	0.89931	0.74020	248.84	Prosper ISD	Individual(s)	NaN	2150.0	W	W	Prosper	2076	Trail	Traditional	ABS A0147 COLLIN COUNTY SCHOOL	1987.0
9	23	75069	3.0	3.0	McKinney	12/18/2013	250000.0	250000.0	856.0	Malvern	Mckinney	Mandatory	269000.0	Less Than .5 Acre (not Zero)	Dr Jack Cockrill	11625707.0	2.0	2.0	2.0	Vacant	250000.0	2.0	False	RES-Single Family	0.92937	1.00000	99.88	McKinney ISD	Individual(s)	NaN	2503.0	NaN	NaN	Preservation	700	Lane	Traditional	Chapel Hill #01b, Blk C, Lot 1	2008.0

Last rows

	df_index	PostalCode	BathsTotal	BedsTotal	City	CloseDate	ClosePrice	CurrentPrice	DOM	ElementarySchoolName	HighSchoolName	AssociationType	ListPrice	LotSize	MiddleSchoolName	MLSNumber	NumberOfDiningAreas	NumberOfLivingAreas	NumberOfStories	Occupancy	OriginalListPrice	ParkingSpacesGarage	PoolYN	PropertySubType	RATIO_ClosePrice_By_ListPrice	RATIO_ClosePrice_By_OriginalListPrice	RATIO_CurrentPrice_By_SQFT	SchoolDistrict	SellerType	SeniorHighSchoolName	SqFtTotal	StreetDirPrefix	StreetDirSuffix	StreetName	StreetNumber	StreetSuffix	ArchitecturalStyle	TaxLegalDescription	YearBuilt
135333	213166	75070	3.1	4.0	McKinney	12/5/2014	264900.0	264900.0	NaN	Bennett	Mckinney Boyd	Mandatory	264900.0	Less Than .5 Acre (not Zero)	Dowell	13050048.0	2.0	3.0	2.0	Vacant	264900.0	2.0	False	RES-Single Family	1.00000	1.00000	86.57	McKinney ISD	Lender/REO	NaN	3060.0	NaN	NaN	Trinity	2401	Lane	NaN	FOUNTAINVIEW #3 (CMC), BLK E, LOT 39	2006.0
135334	213167	75070	3.1	4.0	McKinney	12/5/2014	264900.0	264900.0	NaN	Bennett	Mckinney Boyd	Mandatory	264900.0	Less Than .5 Acre (not Zero)	Dowell	13050048.0	2.0	3.0	2.0	Vacant	264900.0	2.0	False	RES-Single Family	1.00000	1.00000	86.57	McKinney ISD	Lender/REO	NaN	3060.0	NaN	NaN	Trinity	2401	Lane	NaN	FOUNTAINVIEW #3 (CMC), BLK E, LOT 39	2006.0
135335	213168	75071	2.0	4.0	McKinney	12/18/2014	199900.0	199900.0	NaN	Wilmeth	Mckinneyno	Mandatory	199900.0	Less Than .5 Acre (not Zero)	Dr Jack Cockrill	13056859.0	1.0	1.0	1.0	Owner	199900.0	2.0	False	RES-Single Family	1.00000	1.00000	107.24	McKinney ISD	Individual(s)	NaN	1864.0	NaN	NaN	Juno Springs	7720	Way	NaN	VIRGINIA PARKLANDS (CMC), BLK B, LOT 14	2005.0
135336	213169	75071	2.0	4.0	McKinney	12/18/2014	199900.0	199900.0	NaN	Wilmeth	Mckinneyno	Mandatory	199900.0	Less Than .5 Acre (not Zero)	Dr Jack Cockrill	13056859.0	1.0	1.0	1.0	Owner	199900.0	2.0	False	RES-Single Family	1.00000	1.00000	107.24	McKinney ISD	Individual(s)	NaN	1864.0	NaN	NaN	Juno Springs	7720	Way	NaN	VIRGINIA PARKLANDS (CMC), BLK B, LOT 14	2005.0
135337	213171	75075	2.0	4.0	Plano	8/21/2014	235000.0	235000.0	NaN	Davis	Vines	None	235000.0	Less Than .5 Acre (not Zero)	Haggard	13008187.0	2.0	1.0	1.0	NaN	235000.0	2.0	True	RES-Single Family	1.00000	1.00000	102.71	Plano ISD	Individual(s)	Plano Senior	2288.0	NaN	NaN	Cedar Elm	2625	Lane	NaN	TIMBERCREEK ESTATES (CPL), BLK F, LOT 29	1972.0
135338	213172	75078	3.0	5.0	Prosper	2/16/2015	327000.0	327000.0	NaN	Cynthia A Cockrell	Prosper	Mandatory	330000.0	Less Than .5 Acre (not Zero)	Rogers	13086217.0	2.0	3.0	2.0	NaN	330000.0	2.0	False	RES-Single Family	0.99091	0.99091	100.49	Prosper ISD	Individual(s)	NaN	3254.0	NaN	NaN	Crescent Valley	1440	Drive	NaN	CEDAR RIDGE ESTATES (CPR), BLK B, LOT 9	2011.0
135339	213173	75078	3.0	5.0	Prosper	2/16/2015	327000.0	327000.0	NaN	Cynthia A Cockrell	Prosper	Mandatory	330000.0	Less Than .5 Acre (not Zero)	Rogers	13086217.0	2.0	3.0	2.0	NaN	330000.0	2.0	False	RES-Single Family	0.99091	0.99091	100.49	Prosper ISD	Individual(s)	NaN	3254.0	NaN	NaN	Crescent Valley	1440	Drive	NaN	CEDAR RIDGE ESTATES (CPR), BLK B, LOT 9	2011.0
135340	213176	75093	2.0	4.0	Plano	3/19/2015	145000.0	145000.0	NaN	NaN	NaN	None	155000.0	Less Than .5 Acre (not Zero)	NaN	13107447.0	1.0	1.0	1.0	Owner	155000.0	2.0	False	RES-Single Family	0.93548	0.93548	79.32	Plano ISD	Individual(s)	NaN	1828.0	NaN	NaN	Birdsong	4400	Lane	NaN	PRESTON COVE (CPL), BLK D, LOT 1	1980.0
135341	213177	75093	2.0	4.0	Plano	3/19/2015	145000.0	145000.0	NaN	NaN	NaN	None	155000.0	Less Than .5 Acre (not Zero)	NaN	13107447.0	1.0	1.0	1.0	Owner	155000.0	2.0	False	RES-Single Family	0.93548	0.93548	79.32	Plano ISD	Individual(s)	NaN	1828.0	NaN	NaN	Birdsong	4400	Lane	NaN	PRESTON COVE (CPL), BLK D, LOT 1	1980.0
135342	213178	75093	2.0	3.0	Plano	10/30/2014	242500.0	242500.0	NaN	Barksdale	Shepton	Mandatory	259900.0	Less Than .5 Acre (not Zero)	Renner	13024976.0	1.0	1.0	1.0	Vacant	259900.0	2.0	False	RES-Single Family	0.93305	0.93305	131.87	Plano ISD	Individual(s)	Plano West	1839.0	W	NaN	Plano	5161	Parkway	Traditional	OLD SHEPARD PLACE #2 3 & 4 (CPL), BLK C, LOT 9	1985.0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows